<html><head><title>sp_setpglockpromote</title><meta name="HandheldFriendly" content="True"></head><body>Sets lock promotion thresholds.<br><table><tr><td valign=top>1</td><td><a href="y308026.html">For a database or table</a></td></tr><tr><td valign=top>2</td><td><a href="y308027.html">For the server</a></td></tr></table></body></html>